-- @author lixiyong01
-- @date 2023.03.18
-- 治理-表负责人对应任务

CREATE TABLE `hdp_lbg_supin_zplisting.ads_zp_rock_husky_owner_check`(
    `table_id` bigint COMMENT 'DP表id',
    `database_name` string  comment '库名',
    `table_name` string COMMENT '表名',
    `owner_id` string COMMENT '表负责人',
    `task_id` bigint COMMENT 'DP任务id',
    `task_name` string  comment '队列名',
    `queue_name` string COMMENT '任务名',
    `owner_id2` string COMMENT '任务负责人',
    is_partition, lifecycle, filesize, access_last_time, location
) COMMENT '治理-表负责人对应任务'
PARTITIONED BY (`dt` string)